# Get or Post from/to a Pivot Table

**URL:** https://community.dreamfactory.com/t/get-or-post-from-to-a-pivot-table/1043
**Category:** REST API
**Created:** [April 27, 2015, 7:18am UTC](https://community.dreamfactory.com/t/get-or-post-from-to-a-pivot-table/1043 "2015-04-27T07:18:42Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![eivl](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/eivl/32/266_2.png) [@eivl](https://community.dreamfactory.com/u/eivl)
#### Post date: [April 27, 2015, 7:18am UTC](https://community.dreamfactory.com/t/get-or-post-from-to-a-pivot-table/1043/1 "2015-04-27T07:18:42Z")

</div>

I am wondering how you can GET or POST to a Pivot Table?  
Many to Many relationship with two foreign keys.

Please ask me for more details if it is needed 😉

Eivind

---

<div class="post-metadata">

### Author: ![eivl](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/eivl/32/266_2.png) [@eivl](https://community.dreamfactory.com/u/eivl)
#### Post date: [May 8, 2015, 8:52am UTC](https://community.dreamfactory.com/t/get-or-post-from-to-a-pivot-table/1043/2 "2015-05-08T08:52:40Z")

</div>

At the time of writing this is not possible from a normal REST CALL, you must write a SQL Procedure and call it with your input.  
I have written some about it here

> [@Updating Related Table](https://community.dreamfactory.com/t/updating-related-table/1066):
>
> When i try to update field in a related table with two foreign keys (set as primary keys) i get this message. "error": [{ "context": null, "message": "Failed to update many to one assignment.\nRelating records with multiple field primary keys is not currently supported.", "code": 400 }] }``` The related table has two keys, one timestamp field and one "comments" field I would like to be able to : 1: update timestamp and comment field for old entries 2: create n…