SAP / python-pyodata

Enterprise-ready Python OData client
Apache License 2.0
221 stars 93 forks source link

Unable to access a specific svc #16

Closed geophpherie closed 5 years ago

geophpherie commented 5 years ago

I'm hoping access the following API:

https://api.oregonlegislature.gov/odata/odataservice.svc/

I'm able to use your usage example no problem, but when trying to access this svc using those same steps, it doesn't appear to work as expected. Exploring the schema into the entity_sets returns an empty list, so I'm wondering if this svc is not configured in a compatible way? The files (this & the example) appear to be organized in a similar fashion, but I'm completely new to the odata standard and I really don't have any idea what to expect. So I was hoping you could shed a little light on where to start as I dive into this. Thanks.

filak-sap commented 5 years ago

Thank you for taking the time report this issue. Unfortunately, I am not able to connect to the service at the URL https://api.oregonlegislature.gov/odata/odataservice.svc/ so I am not sure how to fix this problem.

Would it be possible to provide your python code and the response data returned by the service for the same request executed from an internet browser (or postman, or curl, or wget)?

phanak-sap commented 5 years ago

It appears that the whole site is currently down. DNS points to 205.143.224.164, which is unreachable.

geophpherie commented 5 years ago

Thank you both for your responses. Here's the response in Postman:

<?xml version="1.0" encoding="utf-8"?>
<service xml:base="https://api.oregonlegislature.gov/odata/ODataService.svc/" xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom">
    <workspace>
        <atom:title>Default</atom:title>
        <collection href="LegislativeSessions">
            <atom:title>LegislativeSessions</atom:title>
        </collection>
        <collection href="Measures">
            <atom:title>Measures</atom:title>
        </collection>
        <collection href="Committees">
            <atom:title>Committees</atom:title>
        </collection>
        <collection href="CommitteeMeetings">
            <atom:title>CommitteeMeetings</atom:title>
        </collection>
        <collection href="CommitteeAgendaItems">
            <atom:title>CommitteeAgendaItems</atom:title>
        </collection>
        <collection href="CommitteeStaffMembers">
            <atom:title>CommitteeStaffMembers</atom:title>
        </collection>
        <collection href="CommitteeMeetingDocuments">
            <atom:title>CommitteeMeetingDocuments</atom:title>
        </collection>
        <collection href="ConveneTimes">
            <atom:title>ConveneTimes</atom:title>
        </collection>
        <collection href="FloorSessionAgendaItems">
            <atom:title>FloorSessionAgendaItems</atom:title>
        </collection>
        <collection href="Legislators">
            <atom:title>Legislators</atom:title>
        </collection>
        <collection href="MeasureAnalysisDocuments">
            <atom:title>MeasureAnalysisDocuments</atom:title>
        </collection>
        <collection href="MeasureDocuments">
            <atom:title>MeasureDocuments</atom:title>
        </collection>
        <collection href="MeasureHistoryActions">
            <atom:title>MeasureHistoryActions</atom:title>
        </collection>
        <collection href="MeasureSponsors">
            <atom:title>MeasureSponsors</atom:title>
        </collection>
        <collection href="CommitteeProposedAmendments">
            <atom:title>CommitteeProposedAmendments</atom:title>
        </collection>
        <collection href="FloorLetters">
            <atom:title>FloorLetters</atom:title>
        </collection>
        <collection href="CommitteeVotes">
            <atom:title>CommitteeVotes</atom:title>
        </collection>
        <collection href="MeasureVotes">
            <atom:title>MeasureVotes</atom:title>
        </collection>
        <collection href="CommitteeMembers">
            <atom:title>CommitteeMembers</atom:title>
        </collection>
    </workspace>
</service>

Heres the response for the metadata (https://api.oregonlegislature.gov/odata/odataservice.svc/$metadata):

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
    <edmx:DataServices m:DataServiceVersion="1.0" m:MaxDataServiceVersion="3.0" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
        <Schema Namespace="State.Or.Leg.API.OData" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
            <EntityType Name="LegislativeSession">
                <Key>
                    <PropertyRef Name="SessionKey" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="SessionName" Type="Edm.String" Nullable="false" MaxLength="30" FixedLength="false" Unicode="false" />
                <Property Name="BeginDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="EndDate" Type="Edm.DateTime" Precision="3" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <Property Name="DefaultSession" Type="Edm.Boolean" Nullable="false" />
                <NavigationProperty Name="Measures" Relationship="State.Or.Leg.API.OData.LegislativeSessionMeasure" ToRole="Measure" FromRole="LegislativeSession" />
                <NavigationProperty Name="Committees" Relationship="State.Or.Leg.API.OData.LegislativeSessionCommittees" ToRole="Committees" FromRole="LegislativeSession" />
                <NavigationProperty Name="Legislators" Relationship="State.Or.Leg.API.OData.LegislativeSessionLegislator" ToRole="Legislator" FromRole="LegislativeSession" />
                <NavigationProperty Name="ConveneTimes" Relationship="State.Or.Leg.API.OData.LegislativeSessionConveneTime" ToRole="ConveneTime" FromRole="LegislativeSession" />
                <NavigationProperty Name="FloorSessionAgendaItems" Relationship="State.Or.Leg.API.OData.LegislativeSessionFloorSessionAgendaItem" ToRole="FloorSessionAgendaItem" FromRole="LegislativeSession" />
                <NavigationProperty Name="FloorLetters" Relationship="State.Or.Leg.API.OData.LegislativeSessionFloorLetter" ToRole="FloorLetter" FromRole="LegislativeSession" />
                <NavigationProperty Name="CommitteeMembers" Relationship="State.Or.Leg.API.OData.LegislativeSessionCommitteeMember" ToRole="CommitteeMember" FromRole="LegislativeSession" />
            </EntityType>
            <EntityType Name="Measure">
                <Key>
                    <PropertyRef Name="MeasureNumber" />
                    <PropertyRef Name="MeasurePrefix" />
                    <PropertyRef Name="SessionKey" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="CatchLine" Type="Edm.String" MaxLength="2000" FixedLength="false" Unicode="false" />
                <Property Name="MinorityCatchLine" Type="Edm.String" MaxLength="2000" FixedLength="false" Unicode="false" />
                <Property Name="MeasureSummary" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="false" />
                <Property Name="CurrentVersion" Type="Edm.String" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="RelatingToFull" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="false" />
                <Property Name="RelatingTo" Type="Edm.String" MaxLength="2000" FixedLength="false" Unicode="false" />
                <Property Name="AtTheRequestOf" Type="Edm.String" MaxLength="1000" FixedLength="false" Unicode="false" />
                <Property Name="ChapterNumber" Type="Edm.String" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CurrentLocation" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="CurrentCommitteeCode" Type="Edm.String" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="CurrentSubCommittee" Type="Edm.String" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="FiscalImpact" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="RevenueImpact" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="EmergencyClause" Type="Edm.Boolean" />
                <Property Name="EffectiveDate" Type="Edm.DateTime" Precision="3" />
                <Property Name="FiscalAnalyst" Type="Edm.String" MaxLength="91" FixedLength="false" Unicode="false" />
                <Property Name="RevenueEconomist" Type="Edm.String" MaxLength="91" FixedLength="false" Unicode="false" />
                <Property Name="LCNumber" Type="Edm.Int32" />
                <Property Name="Vetoed" Type="Edm.Boolean" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <Property Name="PrefixMeaning" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionMeasure" ToRole="LegislativeSession" FromRole="Measure" />
                <NavigationProperty Name="CommitteeAgendaItems" Relationship="State.Or.Leg.API.OData.MeasureCommitteeAgendaItem" ToRole="CommitteeAgendaItem" FromRole="Measure" />
                <NavigationProperty Name="CommitteeMeetingDocuments" Relationship="State.Or.Leg.API.OData.MeasureCommitteeMeetingDocument" ToRole="CommitteeMeetingDocument" FromRole="Measure" />
                <NavigationProperty Name="FloorSessionAgendaItems" Relationship="State.Or.Leg.API.OData.MeasureFloorSessionAgendaItem" ToRole="FloorSessionAgendaItem" FromRole="Measure" />
                <NavigationProperty Name="MeasureDocuments" Relationship="State.Or.Leg.API.OData.MeasureMeasureDocument" ToRole="MeasureDocument" FromRole="Measure" />
                <NavigationProperty Name="MeasureAnalysisDocuments" Relationship="State.Or.Leg.API.OData.MeasureMeasureAnalysisDocument" ToRole="MeasureAnalysisDocument" FromRole="Measure" />
                <NavigationProperty Name="MeasureHistoryActions" Relationship="State.Or.Leg.API.OData.MeasureMeasureHistoryAction" ToRole="MeasureHistoryAction" FromRole="Measure" />
                <NavigationProperty Name="MeasureSponsors" Relationship="State.Or.Leg.API.OData.MeasureMeasureSponsor" ToRole="MeasureSponsor" FromRole="Measure" />
                <NavigationProperty Name="FloorLetters" Relationship="State.Or.Leg.API.OData.FloorLetterMeasure" ToRole="FloorLetter" FromRole="Measure" />
                <NavigationProperty Name="MeasureVote" Relationship="State.Or.Leg.API.OData.MeasureMeasureVote" ToRole="MeasureVote" FromRole="Measure" />
                <NavigationProperty Name="CommitteeVotes" Relationship="State.Or.Leg.API.OData.CommitteeVoteMeasure" ToRole="CommitteeVote" FromRole="Measure" />
            </EntityType>
            <EntityType Name="Committee">
                <Key>
                    <PropertyRef Name="CommitteeCode" />
                    <PropertyRef Name="SessionKey" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeName" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="HouseOfAction" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeType" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="OfficeAddress" Type="Edm.String" MaxLength="5" FixedLength="false" Unicode="false" />
                <Property Name="OfficePhone" Type="Edm.String" MaxLength="15" FixedLength="false" Unicode="false" />
                <Property Name="FaxNumber" Type="Edm.String" MaxLength="15" FixedLength="false" Unicode="false" />
                <Property Name="WebAddress" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="EmailAddress" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="ParentCommitteeCode" Type="Edm.String" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionCommittees" ToRole="LegislativeSession" FromRole="Committees" />
                <NavigationProperty Name="CommitteeMeetings" Relationship="State.Or.Leg.API.OData.CommitteesCommitteeMeetings" ToRole="CommitteeMeetings" FromRole="Committees" />
                <NavigationProperty Name="ParentCommittee" Relationship="State.Or.Leg.API.OData.CommitteesParentCommittees" ToRole="Committees1" FromRole="Committees" />
                <NavigationProperty Name="SubCommittees" Relationship="State.Or.Leg.API.OData.CommitteesParentCommittees" ToRole="Committees" FromRole="Committees1" />
                <NavigationProperty Name="CommitteeStaffMembers" Relationship="State.Or.Leg.API.OData.CommitteeCommitteeStaff" ToRole="CommitteeStaff" FromRole="Committee" />
                <NavigationProperty Name="MeasureAnalysisDocuments" Relationship="State.Or.Leg.API.OData.CommitteeMeasureAnalysisDocument" ToRole="MeasureAnalysisDocument" FromRole="Committee" />
                <NavigationProperty Name="MeasureSponsors" Relationship="State.Or.Leg.API.OData.CommitteeMeasureSponsor" ToRole="MeasureSponsor" FromRole="Committee" />
                <NavigationProperty Name="CommitteeMembers" Relationship="State.Or.Leg.API.OData.CommitteeCommitteeMember" ToRole="CommitteeMember" FromRole="Committee" />
            </EntityType>
            <EntityType Name="CommitteeMeeting">
                <Key>
                    <PropertyRef Name="CommitteeCode" />
                    <PropertyRef Name="MeetingDate" />
                    <PropertyRef Name="SessionKey" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="MeetingDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="Location" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="PostedDate" Type="Edm.DateTime" Precision="3" />
                <Property Name="AlternateLocation" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="AgendaUrl" Type="Edm.String" MaxLength="93" FixedLength="false" Unicode="false" />
                <Property Name="AgendaRevisionNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="MeetingStatusCode" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="MeetingStatus" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="MeetingGuid" Type="Edm.Guid" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Committee" Relationship="State.Or.Leg.API.OData.CommitteesCommitteeMeetings" ToRole="Committees" FromRole="CommitteeMeetings" />
                <NavigationProperty Name="CommitteeAgendaItems" Relationship="State.Or.Leg.API.OData.CommitteeMeetingCommitteeAgendaItem" ToRole="CommitteeAgendaItem" FromRole="CommitteeMeeting" />
                <NavigationProperty Name="CommitteeMeetingDocuments" Relationship="State.Or.Leg.API.OData.CommitteeMeetingCommitteeMeetingDocument" ToRole="CommitteeMeetingDocument" FromRole="CommitteeMeeting" />
            </EntityType>
            <EntityType Name="CommitteeAgendaItem">
                <Key>
                    <PropertyRef Name="CommitteeAgendaItemId" />
                </Key>
                <Property Name="CommitteeAgendaItemId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="MeetingDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="MeasurePrefix" Type="Edm.String" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" />
                <Property Name="BoardName" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="ExecutiveAppointee" Type="Edm.String" MaxLength="90" FixedLength="false" Unicode="false" />
                <Property Name="MeetingType" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="Action" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="PrintOrder" Type="Edm.Decimal" Nullable="false" Precision="5" Scale="0" />
                <Property Name="Comments" Type="Edm.String" MaxLength="2000" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureCommitteeAgendaItem" ToRole="Measure" FromRole="CommitteeAgendaItem" />
                <NavigationProperty Name="CommitteeMeeting" Relationship="State.Or.Leg.API.OData.CommitteeMeetingCommitteeAgendaItem" ToRole="CommitteeMeeting" FromRole="CommitteeAgendaItem" />
                <NavigationProperty Name="CommitteeProposedAmendments" Relationship="State.Or.Leg.API.OData.CommitteeAgendaItemCommitteeProposedAmendment" ToRole="CommitteeProposedAmendment" FromRole="CommitteeAgendaItem" />
                <NavigationProperty Name="CommitteeVotes" Relationship="State.Or.Leg.API.OData.CommitteeVotesCommitteeAgendaItem" ToRole="CommitteeVotes" FromRole="CommitteeAgendaItem" />
            </EntityType>
            <EntityType Name="CommitteeStaff">
                <Key>
                    <PropertyRef Name="CommitteeStaffId" />
                </Key>
                <Property Name="CommitteeStaffId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="FirstName" Type="Edm.String" MaxLength="30" FixedLength="false" Unicode="false" />
                <Property Name="LastName" Type="Edm.String" MaxLength="30" FixedLength="false" Unicode="false" />
                <Property Name="Title" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="PrintOrder" Type="Edm.Decimal" Nullable="false" Precision="5" Scale="0" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Committee" Relationship="State.Or.Leg.API.OData.CommitteeCommitteeStaff" ToRole="Committee" FromRole="CommitteeStaff" />
            </EntityType>
            <EntityType Name="CommitteeMeetingDocument">
                <Key>
                    <PropertyRef Name="CommitteeMeetingDocumentId" />
                </Key>
                <Property Name="CommitteeMeetingDocumentId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="MeetingDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ExhibitReference" Type="Edm.String" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="ExhibitTitle" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="Submitter" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="DocumentType" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" />
                <Property Name="DocumentUrl" Type="Edm.String" MaxLength="200" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="CommitteeMeeting" Relationship="State.Or.Leg.API.OData.CommitteeMeetingCommitteeMeetingDocument" ToRole="CommitteeMeeting" FromRole="CommitteeMeetingDocument" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureCommitteeMeetingDocument" ToRole="Measure" FromRole="CommitteeMeetingDocument" />
            </EntityType>
            <EntityType Name="ConveneTime">
                <Key>
                    <PropertyRef Name="Chamber" />
                    <PropertyRef Name="SessionDate" />
                    <PropertyRef Name="SessionKey" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="SessionDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="Chamber" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="RecessUntil" Type="Edm.DateTime" Precision="3" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionConveneTime" ToRole="LegislativeSession" FromRole="ConveneTime" />
            </EntityType>
            <EntityType Name="FloorSessionAgendaItem">
                <Key>
                    <PropertyRef Name="AgendaId" />
                </Key>
                <Property Name="AgendaId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="ScheduleDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="Version" Type="Edm.String" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="Chamber" Type="Edm.String" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="Completed" Type="Edm.Boolean" />
                <Property Name="OrderOfBusiness" Type="Edm.String" Nullable="false" MaxLength="75" FixedLength="false" Unicode="false" />
                <Property Name="CarrierCode" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Legislator" Relationship="State.Or.Leg.API.OData.LegislatorFloorSessionAgendaItem" ToRole="Legislator" FromRole="FloorSessionAgendaItem" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionFloorSessionAgendaItem" ToRole="LegislativeSession" FromRole="FloorSessionAgendaItem" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureFloorSessionAgendaItem" ToRole="Measure" FromRole="FloorSessionAgendaItem" />
            </EntityType>
            <EntityType Name="Legislator">
                <Key>
                    <PropertyRef Name="LegislatorCode" />
                    <PropertyRef Name="SessionKey" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="LegislatorCode" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="FirstName" Type="Edm.String" Nullable="false" MaxLength="40" FixedLength="false" Unicode="false" />
                <Property Name="LastName" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="CapitolAddress" Type="Edm.String" MaxLength="218" FixedLength="false" Unicode="false" />
                <Property Name="CapitolPhone" Type="Edm.String" MaxLength="15" FixedLength="false" Unicode="false" />
                <Property Name="Title" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="Chamber" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="Party" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="DistrictNumber" Type="Edm.Decimal" Nullable="false" Precision="4" Scale="0" />
                <Property Name="EmailAddress" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="WebSiteUrl" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="FloorSessionAgendaItems" Relationship="State.Or.Leg.API.OData.LegislatorFloorSessionAgendaItem" ToRole="FloorSessionAgendaItem" FromRole="Legislator" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionLegislator" ToRole="LegislativeSession" FromRole="Legislator" />
                <NavigationProperty Name="CommitteeMembers" Relationship="State.Or.Leg.API.OData.LegislatorCommitteeMember" ToRole="CommitteeMember" FromRole="Legislator" />
            </EntityType>
            <EntityType Name="MeasureAnalysisDocument">
                <Key>
                    <PropertyRef Name="MeasureAnalysisId" />
                </Key>
                <Property Name="MeasureAnalysisId" Type="Edm.Decimal" Nullable="false" Precision="18" Scale="0" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommittteCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="DocumentType" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="Version" Type="Edm.String" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="IsMinority" Type="Edm.Boolean" />
                <Property Name="DocumentUrl" Type="Edm.String" MaxLength="199" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureMeasureAnalysisDocument" ToRole="Measure" FromRole="MeasureAnalysisDocument" />
                <NavigationProperty Name="Committee" Relationship="State.Or.Leg.API.OData.CommitteeMeasureAnalysisDocument" ToRole="Committee" FromRole="MeasureAnalysisDocument" />
            </EntityType>
            <EntityType Name="MeasureDocument">
                <Key>
                    <PropertyRef Name="MeasureNumber" />
                    <PropertyRef Name="MeasurePrefix" />
                    <PropertyRef Name="SessionKey" />
                    <PropertyRef Name="VersionDescription" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="VersionDescription" Type="Edm.String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
                <Property Name="DocumentUrl" Type="Edm.String" MaxLength="284" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureMeasureDocument" ToRole="Measure" FromRole="MeasureDocument" />
            </EntityType>
            <EntityType Name="MeasureHistoryAction">
                <Key>
                    <PropertyRef Name="MeasureHistoryId" />
                </Key>
                <Property Name="MeasureHistoryId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="Chamber" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="ActionDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ActionText" Type="Edm.String" MaxLength="1000" FixedLength="false" Unicode="false" />
                <Property Name="VoteText" Type="Edm.String" MaxLength="3000" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <Property Name="PublicNotification" Type="Edm.Boolean" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureMeasureHistoryAction" ToRole="Measure" FromRole="MeasureHistoryAction" />
                <NavigationProperty Name="MeasureVotes" Relationship="State.Or.Leg.API.OData.MeasureHistoryActionMeasureVote" ToRole="MeasureVote" FromRole="MeasureHistoryAction" />
            </EntityType>
            <EntityType Name="MeasureSponsor">
                <Key>
                    <PropertyRef Name="MeasureSponsorId" />
                </Key>
                <Property Name="MeasureSponsorId" Type="Edm.Decimal" Nullable="false" Precision="18" Scale="0" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="SponsorType" Type="Edm.String" Nullable="false" MaxLength="30" FixedLength="false" Unicode="false" />
                <Property Name="LegislatoreCode" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="SponsorLevel" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="PrintOrder" Type="Edm.Decimal" Nullable="false" Precision="18" Scale="0" />
                <Property Name="PresessionFiledMessage" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureMeasureSponsor" ToRole="Measure" FromRole="MeasureSponsor" />
                <NavigationProperty Name="Committee" Relationship="State.Or.Leg.API.OData.CommitteeMeasureSponsor" ToRole="Committee" FromRole="MeasureSponsor" />
            </EntityType>
            <EntityType Name="CommitteeProposedAmendment">
                <Key>
                    <PropertyRef Name="ProposedAmendmentId" />
                </Key>
                <Property Name="ProposedAmendmentId" Type="Edm.Int32" Nullable="false" />
                <Property Name="CommitteeAgendaItemId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="MeetingDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="MeasurePrefix" Type="Edm.String" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" />
                <Property Name="AmendmentNumber" Type="Edm.String" Nullable="false" MaxLength="7" FixedLength="false" Unicode="false" />
                <Property Name="Meaning" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="ProposedAmendmentUrl" Type="Edm.String" MaxLength="320" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="CommitteeAgendaItem" Relationship="State.Or.Leg.API.OData.CommitteeAgendaItemCommitteeProposedAmendment" ToRole="CommitteeAgendaItem" FromRole="CommitteeProposedAmendment" />
            </EntityType>
            <EntityType Name="FloorLetter">
                <Key>
                    <PropertyRef Name="FloorLetterId" />
                </Key>
                <Property Name="FloorLetterId" Type="Edm.Int32" Nullable="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" />
                <Property Name="MeasurePrefix" Type="Edm.String" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="LetterDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="Chamber" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="LetterDescription" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="LetterTitle" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
                <Property Name="FloorLetterUrl" Type="Edm.String" MaxLength="314" FixedLength="false" Unicode="false" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.FloorLetterMeasure" ToRole="Measure" FromRole="FloorLetter" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionFloorLetter" ToRole="LegislativeSession" FromRole="FloorLetter" />
            </EntityType>
            <EntityType Name="CommitteeVote">
                <Key>
                    <PropertyRef Name="CommitteeVoteId" />
                </Key>
                <Property Name="CommitteeVoteId" Type="Edm.Int32" Nullable="false" />
                <Property Name="CommitteeReportId" Type="Edm.Int32" Nullable="false" />
                <Property Name="CommitteeAgendaItemId" Type="Edm.Int32" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="MeetingDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="VoteName" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="Meaning" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="CommitteeAgendaItem" Relationship="State.Or.Leg.API.OData.CommitteeVotesCommitteeAgendaItem" ToRole="CommitteeAgendaItem" FromRole="CommitteeVotes" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.CommitteeVoteMeasure" ToRole="Measure" FromRole="CommitteeVote" />
            </EntityType>
            <EntityType Name="MeasureVote">
                <Key>
                    <PropertyRef Name="MeasureVoteId" />
                </Key>
                <Property Name="MeasureVoteId" Type="Edm.Int32" Nullable="false" />
                <Property Name="MeasureHistoryId" Type="Edm.Int32" Nullable="false" />
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="MeasurePrefix" Type="Edm.String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
                <Property Name="MeasureNumber" Type="Edm.Int32" Nullable="false" />
                <Property Name="Vote" Type="Edm.String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
                <Property Name="Chamber" Type="Edm.String" Nullable="false" MaxLength="1" FixedLength="false" Unicode="false" />
                <Property Name="ActionDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ActionText" Type="Edm.String" MaxLength="1000" FixedLength="false" Unicode="false" />
                <Property Name="VoteName" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="Measure" Relationship="State.Or.Leg.API.OData.MeasureMeasureVote" ToRole="Measure" FromRole="MeasureVote" />
                <NavigationProperty Name="MeasureHistoryAction" Relationship="State.Or.Leg.API.OData.MeasureHistoryActionMeasureVote" ToRole="MeasureHistoryAction" FromRole="MeasureVote" p6:GetterAccess="Public" p6:SetterAccess="Public" xmlns:p6="http://schemas.microsoft.com/ado/2006/04/codegeneration" />
            </EntityType>
            <EntityType Name="CommitteeMember">
                <Key>
                    <PropertyRef Name="CommitteeCode" />
                    <PropertyRef Name="CreatedDate" />
                    <PropertyRef Name="Title" />
                </Key>
                <Property Name="SessionKey" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
                <Property Name="CommitteeCode" Type="Edm.String" Nullable="false" MaxLength="6" FixedLength="false" Unicode="false" />
                <Property Name="LegislatorCode" Type="Edm.String" MaxLength="54" FixedLength="false" Unicode="false" />
                <Property Name="Title" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
                <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" Precision="3" />
                <Property Name="ModifiedDate" Type="Edm.DateTime" Precision="3" />
                <NavigationProperty Name="LegislativeSession" Relationship="State.Or.Leg.API.OData.LegislativeSessionCommitteeMember" ToRole="LegislativeSession" FromRole="CommitteeMember" />
                <NavigationProperty Name="Committee" Relationship="State.Or.Leg.API.OData.CommitteeCommitteeMember" ToRole="Committee" FromRole="CommitteeMember" />
                <NavigationProperty Name="Legislator" Relationship="State.Or.Leg.API.OData.LegislatorCommitteeMember" ToRole="Legislator" FromRole="CommitteeMember" />
            </EntityType>
            <Association Name="LegislativeSessionMeasure">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="Measure">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislativeSessionCommittees">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committees" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="Committees">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislativeSessionLegislator">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.Legislator" Role="Legislator" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="Legislator">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislativeSessionConveneTime">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.ConveneTime" Role="ConveneTime" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="ConveneTime">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislativeSessionFloorSessionAgendaItem">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.FloorSessionAgendaItem" Role="FloorSessionAgendaItem" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="FloorSessionAgendaItem">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislativeSessionFloorLetter">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.FloorLetter" Role="FloorLetter" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="FloorLetter">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislativeSessionCommitteeMember">
                <End Type="State.Or.Leg.API.OData.LegislativeSession" Role="LegislativeSession" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeMember" Role="CommitteeMember" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="LegislativeSession">
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeMember">
                        <PropertyRef Name="SessionKey" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureCommitteeAgendaItem">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.CommitteeAgendaItem" Role="CommitteeAgendaItem" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeAgendaItem">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureCommitteeMeetingDocument">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.CommitteeMeetingDocument" Role="CommitteeMeetingDocument" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeMeetingDocument">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureFloorSessionAgendaItem">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.FloorSessionAgendaItem" Role="FloorSessionAgendaItem" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="FloorSessionAgendaItem">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureMeasureDocument">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureDocument" Role="MeasureDocument" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureDocument">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureMeasureAnalysisDocument">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureAnalysisDocument" Role="MeasureAnalysisDocument" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureAnalysisDocument">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureMeasureHistoryAction">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureHistoryAction" Role="MeasureHistoryAction" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureHistoryAction">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureMeasureSponsor">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureSponsor" Role="MeasureSponsor" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureSponsor">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="FloorLetterMeasure">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.FloorLetter" Role="FloorLetter" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="FloorLetter">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureMeasureVote">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureVote" Role="MeasureVote" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureVote">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeVoteMeasure">
                <End Type="State.Or.Leg.API.OData.Measure" Role="Measure" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeVote" Role="CommitteeVote" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Measure">
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeVote">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeasureNumber" />
                        <PropertyRef Name="MeasurePrefix" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteesCommitteeMeetings">
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committees" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeMeeting" Role="CommitteeMeetings" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Committees">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeMeetings">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="CommitteeCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteesParentCommittees">
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committees1" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committees" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Committees1">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="Committees">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="ParentCommitteeCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeCommitteeStaff">
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committee" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeStaff" Role="CommitteeStaff" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Committee">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeStaff">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="CommitteeCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeMeasureAnalysisDocument">
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committee" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureAnalysisDocument" Role="MeasureAnalysisDocument" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Committee">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureAnalysisDocument">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="CommittteCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeMeasureSponsor">
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committee" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.MeasureSponsor" Role="MeasureSponsor" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Committee">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="MeasureSponsor">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="CommitteeCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeCommitteeMember">
                <End Type="State.Or.Leg.API.OData.Committee" Role="Committee" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeMember" Role="CommitteeMember" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Committee">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeMember">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="CommitteeCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeMeetingCommitteeAgendaItem">
                <End Type="State.Or.Leg.API.OData.CommitteeMeeting" Role="CommitteeMeeting" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeAgendaItem" Role="CommitteeAgendaItem" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="CommitteeMeeting">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="MeetingDate" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeAgendaItem">
                        <PropertyRef Name="CommitteCode" />
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeetingDate" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeMeetingCommitteeMeetingDocument">
                <End Type="State.Or.Leg.API.OData.CommitteeMeeting" Role="CommitteeMeeting" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeMeetingDocument" Role="CommitteeMeetingDocument" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="CommitteeMeeting">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="MeetingDate" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeMeetingDocument">
                        <PropertyRef Name="CommitteeCode" />
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="MeetingDate" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeAgendaItemCommitteeProposedAmendment">
                <End Type="State.Or.Leg.API.OData.CommitteeAgendaItem" Role="CommitteeAgendaItem" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeProposedAmendment" Role="CommitteeProposedAmendment" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="CommitteeAgendaItem">
                        <PropertyRef Name="CommitteeAgendaItemId" />
                    </Principal>
                    <Dependent Role="CommitteeProposedAmendment">
                        <PropertyRef Name="CommitteeAgendaItemId" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="CommitteeVotesCommitteeAgendaItem">
                <End Type="State.Or.Leg.API.OData.CommitteeAgendaItem" Role="CommitteeAgendaItem" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.CommitteeVote" Role="CommitteeVotes" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="CommitteeAgendaItem">
                        <PropertyRef Name="CommitteeAgendaItemId" />
                    </Principal>
                    <Dependent Role="CommitteeVotes">
                        <PropertyRef Name="CommitteeAgendaItemId" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislatorFloorSessionAgendaItem">
                <End Type="State.Or.Leg.API.OData.Legislator" Role="Legislator" Multiplicity="0..1" />
                <End Type="State.Or.Leg.API.OData.FloorSessionAgendaItem" Role="FloorSessionAgendaItem" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Legislator">
                        <PropertyRef Name="LegislatorCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="FloorSessionAgendaItem">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="CarrierCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LegislatorCommitteeMember">
                <End Type="State.Or.Leg.API.OData.Legislator" Role="Legislator" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.CommitteeMember" Role="CommitteeMember" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="Legislator">
                        <PropertyRef Name="LegislatorCode" />
                        <PropertyRef Name="SessionKey" />
                    </Principal>
                    <Dependent Role="CommitteeMember">
                        <PropertyRef Name="SessionKey" />
                        <PropertyRef Name="LegislatorCode" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MeasureHistoryActionMeasureVote">
                <End Type="State.Or.Leg.API.OData.MeasureHistoryAction" Role="MeasureHistoryAction" Multiplicity="1" />
                <End Type="State.Or.Leg.API.OData.MeasureVote" Role="MeasureVote" Multiplicity="*" />
                <ReferentialConstraint>
                    <Principal Role="MeasureHistoryAction">
                        <PropertyRef Name="MeasureHistoryId" />
                    </Principal>
                    <Dependent Role="MeasureVote">
                        <PropertyRef Name="MeasureHistoryId" />
                    </Dependent>
                </ReferentialConstraint>
            </Association>
        </Schema>
        <Schema Namespace="State.Or.Leg.API.Entites" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
            <EntityContainer Name="ApiEntities" m:IsDefaultEntityContainer="true">
                <EntitySet Name="LegislativeSessions" EntityType="State.Or.Leg.API.OData.LegislativeSession" />
                <EntitySet Name="Measures" EntityType="State.Or.Leg.API.OData.Measure" />
                <EntitySet Name="Committees" EntityType="State.Or.Leg.API.OData.Committee" />
                <EntitySet Name="CommitteeMeetings" EntityType="State.Or.Leg.API.OData.CommitteeMeeting" />
                <EntitySet Name="CommitteeAgendaItems" EntityType="State.Or.Leg.API.OData.CommitteeAgendaItem" />
                <EntitySet Name="CommitteeStaffMembers" EntityType="State.Or.Leg.API.OData.CommitteeStaff" />
                <EntitySet Name="CommitteeMeetingDocuments" EntityType="State.Or.Leg.API.OData.CommitteeMeetingDocument" />
                <EntitySet Name="ConveneTimes" EntityType="State.Or.Leg.API.OData.ConveneTime" />
                <EntitySet Name="FloorSessionAgendaItems" EntityType="State.Or.Leg.API.OData.FloorSessionAgendaItem" />
                <EntitySet Name="Legislators" EntityType="State.Or.Leg.API.OData.Legislator" />
                <EntitySet Name="MeasureAnalysisDocuments" EntityType="State.Or.Leg.API.OData.MeasureAnalysisDocument" />
                <EntitySet Name="MeasureDocuments" EntityType="State.Or.Leg.API.OData.MeasureDocument" />
                <EntitySet Name="MeasureHistoryActions" EntityType="State.Or.Leg.API.OData.MeasureHistoryAction" />
                <EntitySet Name="MeasureSponsors" EntityType="State.Or.Leg.API.OData.MeasureSponsor" />
                <EntitySet Name="CommitteeProposedAmendments" EntityType="State.Or.Leg.API.OData.CommitteeProposedAmendment" />
                <EntitySet Name="FloorLetters" EntityType="State.Or.Leg.API.OData.FloorLetter" />
                <EntitySet Name="CommitteeVotes" EntityType="State.Or.Leg.API.OData.CommitteeVote" />
                <EntitySet Name="MeasureVotes" EntityType="State.Or.Leg.API.OData.MeasureVote" />
                <EntitySet Name="CommitteeMembers" EntityType="State.Or.Leg.API.OData.CommitteeMember" />
                <AssociationSet Name="LegislativeSessionMeasure" Association="State.Or.Leg.API.OData.LegislativeSessionMeasure">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="Measure" EntitySet="Measures" />
                </AssociationSet>
                <AssociationSet Name="LegislativeSessionCommittees" Association="State.Or.Leg.API.OData.LegislativeSessionCommittees">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="Committees" EntitySet="Committees" />
                </AssociationSet>
                <AssociationSet Name="LegislativeSessionLegislator" Association="State.Or.Leg.API.OData.LegislativeSessionLegislator">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="Legislator" EntitySet="Legislators" />
                </AssociationSet>
                <AssociationSet Name="LegislativeSessionConveneTime" Association="State.Or.Leg.API.OData.LegislativeSessionConveneTime">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="ConveneTime" EntitySet="ConveneTimes" />
                </AssociationSet>
                <AssociationSet Name="LegislativeSessionFloorSessionAgendaItem" Association="State.Or.Leg.API.OData.LegislativeSessionFloorSessionAgendaItem">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="FloorSessionAgendaItem" EntitySet="FloorSessionAgendaItems" />
                </AssociationSet>
                <AssociationSet Name="LegislativeSessionFloorLetter" Association="State.Or.Leg.API.OData.LegislativeSessionFloorLetter">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="FloorLetter" EntitySet="FloorLetters" />
                </AssociationSet>
                <AssociationSet Name="LegislativeSessionCommitteeMember" Association="State.Or.Leg.API.OData.LegislativeSessionCommitteeMember">
                    <End Role="LegislativeSession" EntitySet="LegislativeSessions" />
                    <End Role="CommitteeMember" EntitySet="CommitteeMembers" />
                </AssociationSet>
                <AssociationSet Name="MeasureCommitteeAgendaItem" Association="State.Or.Leg.API.OData.MeasureCommitteeAgendaItem">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="CommitteeAgendaItem" EntitySet="CommitteeAgendaItems" />
                </AssociationSet>
                <AssociationSet Name="MeasureCommitteeMeetingDocument" Association="State.Or.Leg.API.OData.MeasureCommitteeMeetingDocument">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="CommitteeMeetingDocument" EntitySet="CommitteeMeetingDocuments" />
                </AssociationSet>
                <AssociationSet Name="MeasureFloorSessionAgendaItem" Association="State.Or.Leg.API.OData.MeasureFloorSessionAgendaItem">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="FloorSessionAgendaItem" EntitySet="FloorSessionAgendaItems" />
                </AssociationSet>
                <AssociationSet Name="MeasureMeasureDocument" Association="State.Or.Leg.API.OData.MeasureMeasureDocument">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="MeasureDocument" EntitySet="MeasureDocuments" />
                </AssociationSet>
                <AssociationSet Name="MeasureMeasureAnalysisDocument" Association="State.Or.Leg.API.OData.MeasureMeasureAnalysisDocument">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="MeasureAnalysisDocument" EntitySet="MeasureAnalysisDocuments" />
                </AssociationSet>
                <AssociationSet Name="MeasureMeasureHistoryAction" Association="State.Or.Leg.API.OData.MeasureMeasureHistoryAction">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="MeasureHistoryAction" EntitySet="MeasureHistoryActions" />
                </AssociationSet>
                <AssociationSet Name="MeasureMeasureSponsor" Association="State.Or.Leg.API.OData.MeasureMeasureSponsor">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="MeasureSponsor" EntitySet="MeasureSponsors" />
                </AssociationSet>
                <AssociationSet Name="FloorLetterMeasure" Association="State.Or.Leg.API.OData.FloorLetterMeasure">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="FloorLetter" EntitySet="FloorLetters" />
                </AssociationSet>
                <AssociationSet Name="MeasureMeasureVote" Association="State.Or.Leg.API.OData.MeasureMeasureVote">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="MeasureVote" EntitySet="MeasureVotes" />
                </AssociationSet>
                <AssociationSet Name="CommitteeVoteMeasure" Association="State.Or.Leg.API.OData.CommitteeVoteMeasure">
                    <End Role="Measure" EntitySet="Measures" />
                    <End Role="CommitteeVote" EntitySet="CommitteeVotes" />
                </AssociationSet>
                <AssociationSet Name="CommitteesCommitteeMeetings" Association="State.Or.Leg.API.OData.CommitteesCommitteeMeetings">
                    <End Role="Committees" EntitySet="Committees" />
                    <End Role="CommitteeMeetings" EntitySet="CommitteeMeetings" />
                </AssociationSet>
                <AssociationSet Name="CommitteesParentCommittees" Association="State.Or.Leg.API.OData.CommitteesParentCommittees">
                    <End Role="Committees" EntitySet="Committees" />
                    <End Role="Committees1" EntitySet="Committees" />
                </AssociationSet>
                <AssociationSet Name="CommitteeCommitteeStaff" Association="State.Or.Leg.API.OData.CommitteeCommitteeStaff">
                    <End Role="Committee" EntitySet="Committees" />
                    <End Role="CommitteeStaff" EntitySet="CommitteeStaffMembers" />
                </AssociationSet>
                <AssociationSet Name="CommitteeMeasureAnalysisDocument" Association="State.Or.Leg.API.OData.CommitteeMeasureAnalysisDocument">
                    <End Role="Committee" EntitySet="Committees" />
                    <End Role="MeasureAnalysisDocument" EntitySet="MeasureAnalysisDocuments" />
                </AssociationSet>
                <AssociationSet Name="CommitteeMeasureSponsor" Association="State.Or.Leg.API.OData.CommitteeMeasureSponsor">
                    <End Role="Committee" EntitySet="Committees" />
                    <End Role="MeasureSponsor" EntitySet="MeasureSponsors" />
                </AssociationSet>
                <AssociationSet Name="CommitteeCommitteeMember" Association="State.Or.Leg.API.OData.CommitteeCommitteeMember">
                    <End Role="Committee" EntitySet="Committees" />
                    <End Role="CommitteeMember" EntitySet="CommitteeMembers" />
                </AssociationSet>
                <AssociationSet Name="CommitteeMeetingCommitteeAgendaItem" Association="State.Or.Leg.API.OData.CommitteeMeetingCommitteeAgendaItem">
                    <End Role="CommitteeMeeting" EntitySet="CommitteeMeetings" />
                    <End Role="CommitteeAgendaItem" EntitySet="CommitteeAgendaItems" />
                </AssociationSet>
                <AssociationSet Name="CommitteeMeetingCommitteeMeetingDocument" Association="State.Or.Leg.API.OData.CommitteeMeetingCommitteeMeetingDocument">
                    <End Role="CommitteeMeeting" EntitySet="CommitteeMeetings" />
                    <End Role="CommitteeMeetingDocument" EntitySet="CommitteeMeetingDocuments" />
                </AssociationSet>
                <AssociationSet Name="CommitteeAgendaItemCommitteeProposedAmendment" Association="State.Or.Leg.API.OData.CommitteeAgendaItemCommitteeProposedAmendment">
                    <End Role="CommitteeAgendaItem" EntitySet="CommitteeAgendaItems" />
                    <End Role="CommitteeProposedAmendment" EntitySet="CommitteeProposedAmendments" />
                </AssociationSet>
                <AssociationSet Name="CommitteeVotesCommitteeAgendaItem" Association="State.Or.Leg.API.OData.CommitteeVotesCommitteeAgendaItem">
                    <End Role="CommitteeAgendaItem" EntitySet="CommitteeAgendaItems" />
                    <End Role="CommitteeVotes" EntitySet="CommitteeVotes" />
                </AssociationSet>
                <AssociationSet Name="LegislatorFloorSessionAgendaItem" Association="State.Or.Leg.API.OData.LegislatorFloorSessionAgendaItem">
                    <End Role="FloorSessionAgendaItem" EntitySet="FloorSessionAgendaItems" />
                    <End Role="Legislator" EntitySet="Legislators" />
                </AssociationSet>
                <AssociationSet Name="LegislatorCommitteeMember" Association="State.Or.Leg.API.OData.LegislatorCommitteeMember">
                    <End Role="Legislator" EntitySet="Legislators" />
                    <End Role="CommitteeMember" EntitySet="CommitteeMembers" />
                </AssociationSet>
                <AssociationSet Name="MeasureHistoryActionMeasureVote" Association="State.Or.Leg.API.OData.MeasureHistoryActionMeasureVote">
                    <End Role="MeasureHistoryAction" EntitySet="MeasureHistoryActions" />
                    <End Role="MeasureVote" EntitySet="MeasureVotes" />
                </AssociationSet>
            </EntityContainer>
        </Schema>
    </edmx:DataServices>
</edmx:Edmx>

The python code I ran is here:

import requests
import pyodata
SERVICE_URL = 'https://api.oregonlegislature.gov/odata/odataservice.svc/'
client = pyodata.Client(SERVICE_URL, requests.Session())
print(client.schema.entity_sets) --> []

One other thing I've found is this site which links to this same svc (shows up as #3 for me). It seems to allow exploring what is available as well.

At the moment, that's as far as I've gotten.

Thanks!

filak-sap commented 5 years ago

Thank you for the $metadata. The root cause of this issues is that pyodata fails to parse your version of $metadata. It is caused by an unexpected declaration of XML namespaces and I have to find the proper way for enhancing the parser.

geophpherie commented 5 years ago

Okay understood. Thanks for looking into it.

filak-sap commented 5 years ago

I've created these temporary commits which fix the parse:

You can test it by pulling my private branch: https://github.com/filak-sap/python-pyodata-1/commits/wip_issue_16_api_oregonlegislature_gov but it is not necessary as I will try to push the changes to this repository as soon as possible.